﻿<AdoNetDataAccess connection="$ContactsDBConnection$">
	<Sql>
    UPDATE CONTACTS SET
    lastName=@lastName
    ,firstName=@firstName
    ,middleName=@middleName
    ,phone=@phone
    ,mobile=@mobile
    ,email=@email
    ,isUser=@isUser
    ,typeId=@typeId
    ,extId=@extId
    ,dateUpdated=@dateUpdated
    ,avitarImage=@avitarImage
    ,customTitle=@customTitle
    ,dateOfBirth=@dateOfBirth
    ,gender=@gender
    ,location=@location
    WHERE CONTACTS.id=@id
  </Sql>
	<Sql type="SqlServer">
	</Sql>
	<Param name="id" type="UniqueIdentifier" />
	<Param name="lastName" type="UnicodeVarChar" />
	<Param name="firstName" type="UnicodeVarChar" />
	<Param name="middleName" type="UnicodeVarChar" />
	<Param name="phone" type="UnicodeVarChar" />
	<Param name="mobile" type="UnicodeVarChar" />
	<Param name="email" type="UnicodeVarChar" />
	<Param name="isUser" type="Integer" />
	<Param name="type.id" dbName="typeId" type="UniqueIdentifier" />
  <Param name="extId" type="String" />
  <Param name="dateUpdated" type="Date" />
  <Param name="avitarImage" type="String" />
  <Param name="customTitle" type="String" />
  <Param name="dateOfBirth" type="Date" />
  <Param name="gender" type="String" />
  <Param name="location" type="String" />
</AdoNetDataAccess>